| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Conditional formula for dates
In my spreadsheet for expenses I have a cell for balance at end of month and have another for beginning balance for following month. I put in the formula beginning balance =ending balance but all beginning balances for year are filled for the entire year but I only want a monthly begin balance to show only if we have reached that particular month otherwise be blank or show zero
Can anyone help this poor old soul Thanks for any tips |
|
#2
|
|||
|
|||
|
Quote:
A3 -- =IF(TODAY()=A1,A2,"") |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional formula for dates | Excel Worksheet Functions | |||
| Conditional formula to highlight dates (and that entire row) | Excel Worksheet Functions | |||
| conditional formula based on dates | Excel Worksheet Functions | |||
| formula in conditional formatting with dates | Excel Discussion (Misc queries) | |||
| Conditional formatting formula for past due dates | Excel Discussion (Misc queries) | |||
Linear Mode
