| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date Correction
I have a spreadsheet with 1000+ rows and I need to correct a date column,
This column should contain the last day of the month, but often does not. I am in need of a formula that will check the month and correct to the last calendar day, i.e. November would be 30 and December would be 31. I need to retain the original month and year and correct only the day. Thanks€¦ -- JPS |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Value correction | Excel Discussion (Misc queries) | |||
| Date Auto-Correction | Excel Discussion (Misc queries) | |||
| syntax correction | New Users to Excel | |||
| most recent date (correction) | Excel Discussion (Misc queries) | |||
| correction | Excel Discussion (Misc queries) | |||
Threaded Mode
