check if number is a date

[alexandru barabas]

Hi,
i want to make a code that gives the mounth and the day from two numeric cells. A1- is the day and A2 is the mounth. If A1 or A2 are not an existing calendaristic date than devide with cell A3 only the cell that itș not an existing mounth or day, if values are still not calendaristic date than devide again with cell A4 also only the cell that donțt mach as valid date. If the resulted date is still not calendaristic ( like 31 appril ) than show the first day of the next mounth (like 1 may)

regards

 

[trprasad78]

Hi Alexandra barabas,

Too get quick response, share the sample file.
It help to understand the exact query.

Regards,
-Prasad.

 

[alexandru barabas]

hope this is more clearly. Thanks

 

[NARAYANK991]

Hi ,

See if this works.

Narayan