BeerBeer101
New Member
- Joined
- Dec 29, 2021
- Messages
- 40
- Office Version
- 365
- Platform
- Windows
working on a salary sheet. here is a sample:
so i want to column N to show the current salary based on the current month. so if it's Jan - return the Jan value. when i open the sheet in Feb - it will return the Feb Value...
i CAN at a =now() above as line 1 of colum N - that's totally doable...
i know there's a formula for this! thanks in advance!
so i want to column N to show the current salary based on the current month. so if it's Jan - return the Jan value. when i open the sheet in Feb - it will return the Feb Value...
i CAN at a =now() above as line 1 of colum N - that's totally doable...
i know there's a formula for this! thanks in advance!