| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
date mismatching
when i just set the equation in b column as =DATE(YEAR(A1)+1,MONTH(A1)-1,DAY(A1)-1)
but the date in a column is 01/02/2013 .after putting the equation the date comes in b column as 31/12/2014. actually it should come as 31/01/2014. how can i solve this |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Concatenate including a date so that the date appears as a date | Excel Worksheet Functions | |||
| date in Cell to change colors if the date is beyond today's date | Excel Discussion (Misc queries) | |||
| Report Date - Date Recv = Days Late, but how to rid completed date | Excel Worksheet Functions | |||
| copy date based on date -refer to date range | Excel Programming | |||
| Date updates from worksheet to chart & changes date to a date series! Help!! | Charts and Charting in Excel | |||
Threaded Mode
