| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date of the First day of the previous month
"Hari" skrev i en meddelelse
ups.com... Leo, Thanks a lot. I feel really stupid to not try this. I thought that Month(C2) -1 would give "error" in case value of Month is 1. So, I didnt even try it out. Regards, HP India You are welcome and thanks for the feedback. I know the feeling ;-) Regards Leo |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing a date back one month | Excel Discussion (Misc queries) | |||
| date of last friday of previous month | Excel Discussion (Misc queries) | |||
| How do I break a date range by month? | Excel Discussion (Misc queries) | |||
| Round date to first of month | Excel Discussion (Misc queries) | |||
| Formula for Extracting Month out of a Date column | Excel Discussion (Misc queries) | |||
Hybrid Mode
